package com.dingding.special.order.aboard.sql;

/**
 * 
 * @ClassName: ConfirmAboardSQL 
 * @Description: 确认上车SQL
 * @author YHQ
 * @date 2016年8月21日 下午3:41:09
 * @since V2.4.0
 * 
 */
public class ConfirmAboardSQL {

	/**
	 * 确认上车，获取通知消息
	 */
	public static String GET_CONFIRM_ABOARD_NOTICE_INFO = "SELECT u.specialOrderId as oid,u.orderStatus,u.publishType,ul.aliasId,ul.loginEquipment FROM userspecialordert u INNER JOIN userlogin ul ON u.placeOrderUserId = ul.uid WHERE u.specialOrderId = ?";
	
}
